Between comparisons
When you select Between from the Comparison drop-down list, the Value column changes to display two fields with the word "and" between them. The specified values are inclusive.
When entering numbers for a comparison on a date field (Within Days, Within Months, Within Years), be aware that such comparisons are zero-based. For example, if you select the Last Updated column and select Within Days,
Pattern comparisons
The pattern comparisons (Contains, Not Contains, Starts With, and Ends With) use a simple text field even for a Property that normally contains a discrete drop-down list of values. You can enter multiple values for a pattern comparison by separating each value with a comma. For example, if you want to limit a Last Name - Starts With filter to search only for last names that start with H, I, or P, you would enter H, I, P in the Value field.
Date Values
You can click the calendar icon next to all Date fields to select a date from a pop-up calendar. If you need to specify a specific time on the selected date, first enter the time in the Date field, using 24-hour format (for example, enter 23:00 for 11:00 p.m.), then click the icon to select the date.
Query Options
The Limit the number of results returned checkbox, visible in the Query Options section when in Advanced Mode, enables you to specify a limit to the number of rows that can be returned by the query. By setting the corresponding Prompt to No, you make the specified value a hard limit for the query. By setting the Prompt to Optional or Required, you make the specified value a default that can be overridden by users when they run the query. When coupled with sort criteria, this filter can effect a "top n records" type of result. See Limiting the rows returned by a query for more information.
10.6 Production Release. Updated 7/27/2006 3:53:01 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.